package com.tfriend.scheduler.comp;

import java.util.List;

import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;

public class schedulerDAO extends SqlMapClientDaoSupport{
	
	public void updateContent(schedulerData data) {
		getSqlMapClientTemplate().update("updateContent", data);
	}
	public StringBuffer getSchedulerData() {
		StringBuffer lsXml = new StringBuffer();
        
		lsXml.append("<?xml version=\"1.0\" encoding=\"euc-kr\"?>     \n") 
           .append("<root>                                          \n")
           .append("  <dataset name=\"INPUT\" type=\"INPUT\">       \n")
           .append("    <row n=\"1\" type=\"INSERT\">               \n")
           .append("      <col name=\"TEL_NO\">01072166900</col>    \n")
           .append("      <col name=\"RPNS_YN\">Y</col>             \n")
           .append("    </row>                                      \n")
           .append("  </dataset>                                    \n") 
           .append("  <dataset name=\"INPUT_HEADER\" type=\"INPUT\"> \n")
           .append("    <row n=\"1\" type=\"INSERT\">             \n")
           .append("      <col name=\"APPL_ID\"></col>          \n")
           .append("      <col name=\"CHNL_TP\">PORTAL</col>    \n")
           .append("      <col name=\"LCK\"></col>              \n")
           .append("      <col name=\"LCK_TMSTMP\"></col>       \n")
           .append("      <col name=\"LCK_TP\"></col>           \n")
           .append("      <col name=\"LOGIC_DT\">20120808113046</col>\n")
           .append("      <col name=\"MVNE_CRR_CD\">ONS</col>   \n")
           .append("      <col name=\"ORG_ID\">107200</col>     \n")
           .append("      <col name=\"PROC_NO\"></col>          \n")
           .append("      <col name=\"USR_ID\">011101</col>     \n")
           .append("    </row>                                    \n")
           .append("  </dataset>                                \n") 
           .append("  <dataset name=\"OUTPUT\" type=\"OUTPUT\">     \n")
           .append("    <row n=\"\" type=\"SELECT\">                \n")
           .append("      <col name=\"RTN_CD\"/>                    \n")
           .append("    </row>                                      \n")
           .append("  </dataset>                                    \n")
           .append("</root>                                         \n");
       
		return (StringBuffer) lsXml;
	}
}
